/****** Object:  Stored Procedure dbo.CGO_AccountLogSave    Script Date: Monday, March 28, 2011 ******/
IF EXISTS ( SELECT  *
            FROM    dbo.sysobjects
            WHERE   id = OBJECT_ID(N'dbo.CGO_AccountLogSave')
                    AND OBJECTPROPERTY(id, N'IsProcedure') = 1 ) 
  DROP PROCEDURE dbo.CGO_AccountLogSave
GO

/* -------------------------------------------------------------------------------------
/   AccountLogSave
/  ------------------------------------------------------------------------------------- */
SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO

CREATE PROCEDURE dbo.CGO_AccountLogSave  
  @PortalID INT ,
  @UserID INT ,  
  @Token MONEY ,  
  @PaymentID INT ,
  @Comment VARCHAR(500)
AS 
  DECLARE @RetVal INT
  INSERT  INTO dbo.CGO_AccountLog
          ( UserID ,
            PortalID ,            
            Token ,
            LogTime ,
            PaymentID ,
            Comment
          )
  VALUES  ( @UserID ,
            @PortalID ,
            @Token ,
            GETDATE() ,
            @PaymentID ,
            @Comment
          )
  SET @RetVal = SCOPE_IDENTITY()
  SELECT  @RetVal
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO